DSP® Application Development

Add Reserved Columns to Tables

Reserved columns have assigned behaviors and can be added to any table.

The Data Type indicated must be used for the assigned behavior to work as expected.

This table lists the most commonly used Reserved columns.

Column

Data Type

Notes

boaStatus

int
  • As a best practice, should be added to all page tables to record the event status of a record

NOTE: This column is required if there is an OnValidate event on the page where the DSP® needs to set the status of the field.

  • Can be added to a web view to display the current event status of a record

boaAudit

int
  • Can be added to a web view to control the accessibility of the Audit column when Audit is set up for that table within the DSP®
  • Accepts standard Control Status values (0, 1, 2)

boaAdd

int
  • Can be added to a web view to control the ability to add records when Insert is supported for the page
  • Accepts standard Control Status values (0, 1 ,2)

boaEdit

int
  • Can be added to a web view to control the ability to edit records when Update is supported for the page
  • Accepts standard Control Status values (0, 1, 2)

boaDelete

int
  • Can be added to a web view to control the ability to delete records when Delete is supported for the page
  • Accepts standard Control Status values (0, 1, 2)

AddedOn

smalldatetime
  • As a best practice should be added to all page tables to record the date and time when the record was added
  • Generally not included in the web views

AddedBy

nvarchar (50)
  • As a best practice should be added to all page tables to record the UserID who added the record
  • Generally not included in the web views

AddedVia

nvarchar(50)

As a best practice should be added to all page tables to record the DSP® process that added the record.

ChangedOn

smalldatetime
  • As a best practice should be added to all page tables to record the date and time when the record was changed
  • Generally not included in the web views

ChangedBy

nvarchar (50)
  • As a best practice should be added to all page tables to record the UserID who changed the record
  • Generally not included in the web views.

ChangedVia

nvarchar(50)

As a best practice should be added to all page tables to record the DSP® process that changed the record.

LockedBy

nvarchar (50)
  • As a best practice should be added to any page table where multiple users are expected to update the same page
  • This records the UserID of the person currently locking a record (has the record in EDIT mode)
  • This also prevents the record from being edited by another user at the same time
  • Generally not included in the web views

LockedOn

smalldatetime
  • As a best practice should be added to any page table where multiple users are expected to update the same page
  • This records the date and time when a record was locked
  • Generally not included in the web views

WorkflowedOn

smalldatetime
  • As a best practice should be added to all page tables to record the date and time when workflow event was executed from this record
  • Generally not included in the web views

WorkflowedBy

nvarchar(50)
  • As a best practiceshould be added to all page tables to record the UserID who executed the workflow event from this record
  • Generally not included in the web views